namespace Infrastructure.Data.Uow.Migrations
{
    using System;
    using System.Data.Entity.Migrations;
    
    public partial class AddAllTables : DbMigration
    {
        public override void Up()
        {
            CreateTable(
                "ArticleClass",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        Name = c.String(),
                        ParentId = c.Int(nullable: false),
                        Remark = c.String(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "ArticleComm",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        ArticleId = c.Int(nullable: false),
                        Content = c.String(),
                        Fen = c.Int(nullable: false),
                        ParentId = c.Int(nullable: false),
                        ClientType = c.String(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "ArticleInfo",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        Title = c.String(),
                        SubTitle = c.String(),
                        Content = c.String(),
                        ViewCount = c.Int(nullable: false),
                        Source = c.String(),
                        Remark = c.String(),
                        UserId = c.Int(nullable: false),
                        UserName = c.String(),
                        IsAud = c.Boolean(nullable: false),
                        IsDelete = c.Boolean(nullable: false),
                        IsVouch = c.Boolean(nullable: false),
                        IsTop = c.Boolean(nullable: false),
                        AudTime = c.DateTime(),
                        DeleteTime = c.DateTime(),
                        VouchTime = c.DateTime(),
                        TopTime = c.DateTime(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "ArticleInfoClass",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        ArticleId = c.Int(nullable: false),
                        ClassId = c.Int(nullable: false),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "ArticlePic",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        ArticleId = c.Int(nullable: false),
                        PicInfoId = c.Int(nullable: false),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "ArticleTag",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        Name = c.String(),
                        ArticleId = c.Int(nullable: false),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "Goods",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        Name = c.String(),
                        Remark = c.String(),
                        Price = c.Double(nullable: false),
                        DiscountRemark = c.String(),
                        UserId = c.Int(nullable: false),
                        UserName = c.String(),
                        IsAud = c.Boolean(nullable: false),
                        IsDelete = c.Boolean(nullable: false),
                        IsVouch = c.Boolean(nullable: false),
                        IsTop = c.Boolean(nullable: false),
                        AudTime = c.DateTime(),
                        DeleteTime = c.DateTime(),
                        VouchTime = c.DateTime(),
                        TopTime = c.DateTime(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "GoodsImportLog",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        PhyPrePath = c.String(),
                        Name = c.String(),
                        SourceName = c.String(),
                        WebPrePath = c.String(),
                        WebFullPath = c.String(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "GoodsPic",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        GoodsId = c.Int(nullable: false),
                        PicInfoId = c.Int(nullable: false),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "Log",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        TypeId = c.Int(),
                        UserId = c.Int(),
                        PageUrl = c.String(),
                        ReferrerUrl = c.String(),
                        FullMessage = c.String(),
                        ShortMessage = c.String(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "MobileClient",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        Name = c.String(),
                        Remark = c.String(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "MvcAction",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        ControllerId = c.Int(nullable: false),
                        Name = c.String(),
                        Remark = c.String(),
                        ClassId = c.Int(nullable: false),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "MvcActionClass",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        Name = c.String(),
                        Remark = c.String(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "MvcController",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        ClassId = c.Int(nullable: false),
                        AssemblyFullName = c.String(),
                        Name = c.String(),
                        Remark = c.String(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "MvcControllerClass",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        Name = c.String(),
                        Remark = c.String(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "MvcRolePermission",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        ActionId = c.Int(nullable: false),
                        RoleId = c.Int(nullable: false),
                        Name = c.String(),
                        Remark = c.String(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "PicClass",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        Name = c.String(),
                        ParentId = c.Int(nullable: false),
                        Remark = c.String(),
                        UserId = c.Int(nullable: false),
                        UserName = c.String(),
                        IsAud = c.Boolean(nullable: false),
                        IsDelete = c.Boolean(nullable: false),
                        IsVouch = c.Boolean(nullable: false),
                        IsTop = c.Boolean(nullable: false),
                        AudTime = c.DateTime(),
                        DeleteTime = c.DateTime(),
                        VouchTime = c.DateTime(),
                        TopTime = c.DateTime(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "PicComm",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        PicId = c.Int(nullable: false),
                        Content = c.String(),
                        Fen = c.Int(nullable: false),
                        ParentId = c.String(),
                        ClientType = c.String(),
                        UserId = c.Int(nullable: false),
                        UserName = c.String(),
                        IsAud = c.Boolean(nullable: false),
                        IsDelete = c.Boolean(nullable: false),
                        IsVouch = c.Boolean(nullable: false),
                        IsTop = c.Boolean(nullable: false),
                        AudTime = c.DateTime(),
                        DeleteTime = c.DateTime(),
                        VouchTime = c.DateTime(),
                        TopTime = c.DateTime(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "PicInfo",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        Name = c.String(),
                        Remark = c.String(),
                        ViewCount = c.Int(nullable: false),
                        WebFullPath = c.String(),
                        Source = c.String(),
                        Width = c.Int(nullable: false),
                        Height = c.Int(nullable: false),
                        SourceName = c.String(),
                        PhyPrePath = c.String(),
                        WebPrePath = c.String(),
                        UserId = c.Int(nullable: false),
                        UserName = c.String(),
                        IsAud = c.Boolean(nullable: false),
                        IsDelete = c.Boolean(nullable: false),
                        IsVouch = c.Boolean(nullable: false),
                        IsTop = c.Boolean(nullable: false),
                        AudTime = c.DateTime(),
                        DeleteTime = c.DateTime(),
                        VouchTime = c.DateTime(),
                        TopTime = c.DateTime(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "PicInfoClass",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        PicId = c.Int(nullable: false),
                        ClassId = c.Int(nullable: false),
                        UserId = c.Int(nullable: false),
                        UserName = c.String(),
                        IsAud = c.Boolean(nullable: false),
                        IsDelete = c.Boolean(nullable: false),
                        IsVouch = c.Boolean(nullable: false),
                        IsTop = c.Boolean(nullable: false),
                        AudTime = c.DateTime(),
                        DeleteTime = c.DateTime(),
                        VouchTime = c.DateTime(),
                        TopTime = c.DateTime(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "PicTag",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        Name = c.String(),
                        PicId = c.Int(nullable: false),
                        UserId = c.Int(nullable: false),
                        UserName = c.String(),
                        IsAud = c.Boolean(nullable: false),
                        IsDelete = c.Boolean(nullable: false),
                        IsVouch = c.Boolean(nullable: false),
                        IsTop = c.Boolean(nullable: false),
                        AudTime = c.DateTime(),
                        DeleteTime = c.DateTime(),
                        VouchTime = c.DateTime(),
                        TopTime = c.DateTime(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "PicThumb",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        SourceName = c.String(),
                        Remark = c.String(),
                        ViewCount = c.Int(nullable: false),
                        WebFullPath = c.String(),
                        PicId = c.Int(nullable: false),
                        Width = c.Int(nullable: false),
                        Height = c.Int(nullable: false),
                        Name = c.String(),
                        WebPrePath = c.String(),
                        PhyPrePath = c.String(),
                        UserId = c.Int(nullable: false),
                        UserName = c.String(),
                        IsAud = c.Boolean(nullable: false),
                        IsDelete = c.Boolean(nullable: false),
                        IsVouch = c.Boolean(nullable: false),
                        IsTop = c.Boolean(nullable: false),
                        AudTime = c.DateTime(),
                        DeleteTime = c.DateTime(),
                        VouchTime = c.DateTime(),
                        TopTime = c.DateTime(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "PicThumbSize",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        ThumbWidth = c.Int(nullable: false),
                        ThumbHeight = c.Int(nullable: false),
                        Name = c.String(),
                        Remark = c.String(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "Role",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        Name = c.String(),
                        Remark = c.String(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "Schedule",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        Name = c.String(),
                        Remark = c.String(),
                        ScheduleDate = c.DateTime(nullable: false),
                        BeginTime = c.DateTime(nullable: false),
                        EndTime = c.DateTime(nullable: false),
                        ScheduleDateTime = c.String(),
                        UserId = c.Int(nullable: false),
                        UserName = c.String(),
                        IsAud = c.Boolean(nullable: false),
                        IsDelete = c.Boolean(nullable: false),
                        IsVouch = c.Boolean(nullable: false),
                        IsTop = c.Boolean(nullable: false),
                        AudTime = c.DateTime(),
                        DeleteTime = c.DateTime(),
                        VouchTime = c.DateTime(),
                        TopTime = c.DateTime(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "ScheduleImportLog",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        PhyPrePath = c.String(),
                        Name = c.String(),
                        SourceName = c.String(),
                        WebPrePath = c.String(),
                        WebFullPath = c.String(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "SightPoint",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        Name = c.String(),
                        Remark = c.String(),
                        Lat = c.Double(nullable: false),
                        Lon = c.Double(nullable: false),
                        ClassId = c.Int(nullable: false),
                        Address = c.String(),
                        AreaId = c.Int(nullable: false),
                        InternalId = c.Int(nullable: false),
                        UserId = c.Int(nullable: false),
                        UserName = c.String(),
                        IsAud = c.Boolean(nullable: false),
                        IsDelete = c.Boolean(nullable: false),
                        IsVouch = c.Boolean(nullable: false),
                        IsTop = c.Boolean(nullable: false),
                        AudTime = c.DateTime(),
                        DeleteTime = c.DateTime(),
                        VouchTime = c.DateTime(),
                        TopTime = c.DateTime(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "SightPointArea",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        Name = c.String(),
                        Remark = c.String(),
                        AreaType = c.String(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "SightPointClass",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        Name = c.String(),
                        Remark = c.String(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "SightPointComm",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        SightId = c.Int(nullable: false),
                        SightName = c.String(),
                        Contents = c.String(),
                        UserId = c.Int(nullable: false),
                        UserName = c.String(),
                        ClientId = c.Int(nullable: false),
                        IsReply = c.Boolean(nullable: false),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "SightPointCommReply",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        CommId = c.Int(nullable: false),
                        Contents = c.String(),
                        UserId = c.Int(nullable: false),
                        UserName = c.String(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "SightPointGoods",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        SightId = c.Int(nullable: false),
                        GoodsId = c.Int(nullable: false),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "SightPointImportLog",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        PhyPrePath = c.String(),
                        Name = c.String(),
                        SourceName = c.String(),
                        WebPrePath = c.String(),
                        WebFullPath = c.String(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "SightPointPic",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        SightId = c.Int(nullable: false),
                        PicInfoId = c.Int(nullable: false),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "SightPointUserSigin",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        SightId = c.Int(nullable: false),
                        UserId = c.Int(nullable: false),
                        UserName = c.String(),
                        ClientId = c.Int(nullable: false),
                        Contents = c.String(),
                        SightName = c.String(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "Tour",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        Name = c.String(),
                        Remark = c.String(),
                        TourDate = c.DateTime(nullable: false),
                        BeginTime = c.DateTime(nullable: false),
                        EndTime = c.DateTime(nullable: false),
                        UserId = c.Int(nullable: false),
                        UserName = c.String(),
                        IsAud = c.Boolean(nullable: false),
                        IsDelete = c.Boolean(nullable: false),
                        IsVouch = c.Boolean(nullable: false),
                        IsTop = c.Boolean(nullable: false),
                        AudTime = c.DateTime(),
                        DeleteTime = c.DateTime(),
                        VouchTime = c.DateTime(),
                        TopTime = c.DateTime(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "TourImportLog",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        PhyPrePath = c.String(),
                        Name = c.String(),
                        SourceName = c.String(),
                        WebPrePath = c.String(),
                        WebFullPath = c.String(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "TourPic",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        TourId = c.Int(nullable: false),
                        PicInfoId = c.Int(nullable: false),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "User",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        UserName = c.String(),
                        Pwd = c.String(),
                        TrueName = c.String(),
                        Sex = c.Boolean(nullable: false),
                        Phone = c.String(),
                        UserType = c.Int(),
                        Guid = c.String(),
                        DepartmentID = c.Int(),
                        Email = c.String(),
                        IsActivity = c.Boolean(nullable: false),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "UserExtension",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        UserId = c.Int(nullable: false),
                        SinaWeiboId = c.String(),
                        SinaWeiboScreenName = c.String(),
                        QQWeiboId = c.String(),
                        QQWeiboScreenName = c.String(),
                        QQNum = c.String(),
                        UserName = c.String(),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
            CreateTable(
                "UserRole",
                c => new
                    {
                        Id = c.Int(nullable: false, identity: true),
                        UserId = c.Int(nullable: false),
                        RoleId = c.Int(nullable: false),
                        AddTime = c.DateTime(nullable: false),
                        IpAddress = c.String(),
                        State = c.Boolean(nullable: false),
                        SortNum = c.Int(nullable: false),
                    })
                .PrimaryKey(t => t.Id);
            
        }
        
        public override void Down()
        {
            DropTable("UserRole");
            DropTable("UserExtension");
            DropTable("User");
            DropTable("TourPic");
            DropTable("TourImportLog");
            DropTable("Tour");
            DropTable("SightPointUserSigin");
            DropTable("SightPointPic");
            DropTable("SightPointImportLog");
            DropTable("SightPointGoods");
            DropTable("SightPointCommReply");
            DropTable("SightPointComm");
            DropTable("SightPointClass");
            DropTable("SightPointArea");
            DropTable("SightPoint");
            DropTable("ScheduleImportLog");
            DropTable("Schedule");
            DropTable("Role");
            DropTable("PicThumbSize");
            DropTable("PicThumb");
            DropTable("PicTag");
            DropTable("PicInfoClass");
            DropTable("PicInfo");
            DropTable("PicComm");
            DropTable("PicClass");
            DropTable("MvcRolePermission");
            DropTable("MvcControllerClass");
            DropTable("MvcController");
            DropTable("MvcActionClass");
            DropTable("MvcAction");
            DropTable("MobileClient");
            DropTable("Log");
            DropTable("GoodsPic");
            DropTable("GoodsImportLog");
            DropTable("Goods");
            DropTable("ArticleTag");
            DropTable("ArticlePic");
            DropTable("ArticleInfoClass");
            DropTable("ArticleInfo");
            DropTable("ArticleComm");
            DropTable("ArticleClass");
        }
    }
}
